package com.example.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.entity.StudentInformation;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.List;

/**
 * @author 陈俊杰
 */
@Component
@Mapper
public interface AssessorPlusDao extends BaseMapper<StudentInformation> {

    /**
     * 获取投票名单
     * @return
     */
    @Select("select s.student_id,name from student_information s,result r where s.student_id=r.student_id and first_trial_result='1' and vote_result='2'")
    public List<StudentInformation> getVoteName();
}
